﻿CREATE PROCEDURE [dbo].[ETL_SP_GetTaskParameters]
	@taskId uniqueidentifier
AS
select TP.*,
	DSP.Name,
	DSP.DataType
from ETL_TaskParameter as TP
	inner join ETL_DtSourceParameter as DSP on DSP.Id = TP.DtSourceParameterId
where TP.TaskId = @taskId
order by TP.[Index] ASC
RETURN 0
